import pandas as pd

df = pd.read_excel("./data/外包服务清单.xlsx")

df = df.groupby(["业务动作"])
resdf = pd.DataFrame()
for i in df.indices:
	tmpdf = pd.DataFrame(df.get_group(i))
	txt = ""
	for j in tmpdf.index:
		txt += tmpdf.loc[j, "服务内容"] + "|||"
	tmpdf.loc[tmpdf.index[0], "服务内容"] = txt[:-3]
	resdf = pd.concat([resdf, tmpdf.iloc[[0], :]])
print(resdf)
